Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
-
Re: How do I change YTD to FYTD in a measure column?
These are the formulas…assuming you are filtering on accounting period name, and filter on balance type (ie: A for Actual). Attached is XML for a simple version with prompts for concatenated segment …1 -
Re: Looking for PO line quantity column in Purchasing Subject Areas
Hi, See if this works in your instance, you may need both line and distribution sequence for it to appear. You also mentioned about blank, double check you currency settings from the catalog my accou…2 -
Re: OTBI Export to Excel or CSV limitation
I says voting is now open! This is so needed, and so long overdue4 -
Re: SQL editor for Oracle BI
Hi, It costs money, but well worth it for our developers, we use sqlconnect https://sqlconnect.com/1 -
Re: Report 2x - 5xing values when using the hierarchical tiers
Hi, Do you have multiple/alternate hierarchies (or even base and current) in account dimension? If yes, try adding a filter for the "tree filter" under natural account. (or tree filter for …1
